09/09/2021
Introduction
Jonathan
The Team
- Derek - Life Expectancy SME
- John Paul - Smoking SME
- JP - Drug Abuse SME
- Prathiba - R Shiny Dashboard Architect
- Paddy - Spatial Data Guru
Key findings - Life expectancy
Derek
The Data
- What is life expectancy and why it was chosen?
Life expectancy is a statistical measure of the average time an organism is expected to live, based on the year of its birth, its current age and any other demographic factors including sex and geographic area.
- The source of the data
statistics.gov.uk
- Why was this data selected?
Trend - Dumfries & Galloway
Trend - Scotland
Rank - Local Authority
Key Findings
- In Scotland in 2017-2019, the life expectancy at birth was 77.1 years for males, and 81.1 years for females.
- Life expectancy since 1991-1993 has increased but has largely remained unchanged since 2013-2015.
- Female life expectancy is lowest at birth in Glasgow (78.5 years) and highest in East Renfrewshire (84 years).
- Male life expectancy is lowest at birth in Glasgow (73.6 years) and highest in East Dunbartonshire (80.5 years).
- The majority of Scotland’s council areas have seen a slow down in life expectancy since 2013-2015, with some seeing a decrease.
Key findings - Smoking
John Paul
The data
The data set used for this was: Smoking - Scottish Survey Core Questions
The data was sourced from: statistics.gov.uk
Why it was chosen We chose Smoking as two of the Scottish Government’s National Performance Framework (NPF) National Indicators are relevant to smoking.
There is a strong Public Health focus on reducing the proportion of adults who smoke.
Trend
The overview is optimistic.
Whilst numbers are still higher than anyone would like, the long term trend shows a steady reduction in all age groups.
Rank
In some areas you are 300% more likely to smoke than in other areas.
Rank - continued
Where you live dictates how likely you are to smoke.
Map
There are huge variations around the country, whether they be measured by NHS Health Board or the more granular Local Authority areas.
Essentially the areas with the lowest proportion of smokers are more affluent. The opposite is also true.
- Findings
More work needs to be in less affluent areas to further reduce the rate of smoking.
Key findings - Drug abuse
Jonathan
The data
- Scottish Drug Misuse Database
- https://www.opendata.nhs.scot/
- Published by Public Health Scotland - the national public health body for Scotland
- Why was this data selected?
Trend by gender
Trend by age group
Rank
